USE [influenza]
GO

/****** Object:  StoredProcedure [dbo].[SP_cmbLaboratorio]    Script Date: 04/16/2010 18:04:58 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


-- =============================================
CREATE PROCEDURE [dbo].[SP_cmbLaboratorio]
@param varchar(3)
AS
BEGIN
declare @qry VARCHAR(8000)
SET @qry = 'select 99,''NACIONAL'' UNION ALL
select id_laboratorio,cLaboratorio 
FROM cat_laboratorio'
			
exec(@qry)	
END
GO

